package com.qf.mapper;

import com.qf.model.Stage;
import com.qf.model.Taskplan;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TaskplanMapper {


    //当前页结果
    public List<Taskplan> findPage(@Param("currentPage")Integer currentPage, @Param("pageSize")Integer pageSize, @Param("queryString")String queryString);


    //总记录数

    public Long count(String queryString);

    //添加一个taskplan
    public int addOne(Taskplan taskplan);

    //根据tid查询taskplan
    public Taskplan findById(String tid);

    //修改taskplan
    int editOne(Taskplan taskplan);

    //删除taskplan
    int delete(String tid);

    @Select("select * from taskplan where bid=#{bid} and status=1 ")
    List<Taskplan> findByBid (String bid);


}
